﻿USE [RestaurantManagement]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- =============================================
CREATE PROCEDURE [dbo].[Insert_Restaurant] 
		@RestaurantID as uniqueidentifier,
		@RestaurantCode as varchar(20),
		@RestaurantName as nvarchar(255),
		@Address as nvarchar(255),
		@PhoneNumber as varchar(20),
		@Fax as varchar(20),
		@Email as varchar(100),
		@Website as varchar(100),
		@TaxCode as varchar(20),
		@IsAgencies as bit,
		@IsActive as bit,
		@Description as nvarchar(255)
AS
INSERT INTO dbo.[Restaurant](
			RestaurantCode,
			RestaurantName,
			Address,
			PhoneNumber,
			Fax,
			Email,
			Website,
			TaxCode,
			IsAgencies,
			IsActive,
			Description)
VALUES(
			@RestaurantCode,
			@RestaurantName,
			@Address,
			@PhoneNumber,
			@Fax,
			@Email,
			@Website,
			@TaxCode,
			@IsAgencies,
			@IsActive,
			@Description)
GO
